USE DB_TCC
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME LIKE 'P_FORMACAO_CONSULTAR')
	DROP PROCEDURE P_FORMACAO_CONSULTAR
GO
CREATE PROCEDURE P_FORMACAO_CONSULTAR(
	@IDFORMACAO INTEGER)
AS BEGIN
	SELECT
		IDFORMACAO,
		IDCURRICULO,
		INSTITUICAO,
		PAISINSTITUICAO,
		UFINSTITUICAO,
		CIDADEINSTITUICAO,
		TIPOFORMACAO,
		CURSO,
		DURACAOHORAS,
		DTINICIO,
		DTTERMINO,
		INDSITUACAO,
		DTHRINCLUSAO,
		DTHRALTERACAO
	FROM
		FORMACAO
	WHERE
		IDFORMACAO = @IDFORMACAO
END